<?php

class VendorpartsController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column2';

	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
		
				'users'=>array('@'),
			),
		
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id)
	{
		$this->render('view',array(
			'model'=>$this->loadModel($id),
		));
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate($partno)
	{
		$model=new Vendorparts;               
		$model->attributes=$_POST;
                $model->partno=$partno;
                if($model->save()){
                    echo json_encode(array(
                        'success'=>true,
                        'msg'=>'Update successful'
                    ));
                }else{
                    echo json_encode(array(
                        'errors'=>$model->getErrors()
                    ));
                }
                
                Yii::app()->end();
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id)
	{
		$model=$this->loadModel($id);

	
                $model->attributes=$_POST;
                if($model->save()){
                    echo json_encode(array(
                        'success'=>true,
                        'msg'=>'Update successful'
                    ));
                }else{
                    echo json_encode(array(
                        'errors'=>$model->getErrors()
                    ));
                }
			
		Yii::app()->end();

	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id)
	{
		
			// we only allow deletion via POST request
			$model=$this->loadModel($id);
                        $partno=$model->partno;
                        $model->delete();
			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
			
		
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex($partno)
	{
		
		$this->render('index',array(
                    'inventory'=>$this->loadInventory($partno)
		));
	}
        public function loadInventory($partno){
            $model= Inventory::model()->findByPk($partno);           
            if($model===null)
                    throw new CHttpException(404,'The requested page does not exist.');
            return $model;
        }

	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id)
	{
		$model=Vendorparts::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}
        
	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='vendorparts-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
        public function actionList($partno,$page=0,$sort=NULL){
            if($page>0) $page--;
            $order=CJSON::decode($sort);
            $crit=new CDbCriteria();
            if($partno!=NULL){
                $crit->condition='partno=:partno';
                $crit->params=array(
                    'partno'=>$partno
                );
                $crit->order=isset($order)?$order[0]['property'].' '.$order[0]['direction']:NULL;
            }
            
            $data=new CActiveDataProvider('Vendorparts',array(
                'criteria'=>$crit,
                'pagination'=>array(
                    'pageSize'=>20,
                    'currentPage'=>$page
                )
            ));
            
            if($data!=NULL && count($data->getData())>0){
                $rs=array();
                $rs['totalCount']=$data->getTotalItemCount();
                foreach($data->getData() as $i=>$item){
                    /* var inventoryquality $item*/
                    $rs['data'][$i]=$item->getAttributes();
                    $rs['data'][$i]['vendorName']=Inventory::model()->getVendorText($item->vendor);
                    $rs['data'][$i]['id']=$item->int;
                }
                echo json_encode($rs);
            }
            Yii::app()->end();
        }
        public function actionVendorList(){
            $ventorList=Yii::app()->db->createCommand('select vendor,company,firstname from tbl_vendors')->queryAll();
            echo json_encode($ventorList);
            Yii::app()->end();
        }
}
